#!/bin/bash

-- 陈盼盼
/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/nev?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *, '2024-08-20' as dt from web_chat_text_ems_2019_07 where 1=1 and \$CONDITIONS" \
--hcatalog-database oe_ods \
--hcatalog-table t_web_chat_text_ems \
-m 1

-- 陈盼盼
/usr/bin/sqoop import "-Dorg.apache.sqoop.splitter.allow_text_splitter=true" \
--connect 'jdbc:mysql://192.168.88.80:3306/nev?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true' \
--username root \
--password 123456 \
--query "select *, '2024-08-20' as dt from web_chat_ems_2019_07 where 1=1 and \$CONDITIONS" \
--hcatalog-database oe_ods \
--hcatalog-table t_web_chat \
-m 1